<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
   <%@ page  import="java.sql.*" %>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    
        <body bgcolor="lightblue"   text="black">
            
           <center>   <img src="images/images/title.jpg" alt="" width="636" height="87" /><br /></center>
           <br><br>

        <center><i><u><font size="8">courses</font></u></i></center>
   <table>
       
       <tr>
       <td>
   <table border="4"  cellspacing="7" cellpadding="7">
<thead>

</thead>
<tbody>
<tr>
    <td><a href="viewall.jsp">VIEWCOURSES</a></td>

</tr>
<tr>
    <td><a href="facultydiscussionforum.jsp">DISCUSSIONFORUM</a></td>

</tr>
<tr>
    <td><a href="uploadmaterial.jsp">UPLOADMATERIAL</a></td>

</tr>
<tr>
    <td><a href="facultyuploadassignment.jsp">UPLOAD ASSIGNMENT</a></td>

</tr>

<tr>
    <td><a href="viewmaterial.jsp">VIEWMATERIAL</a></td>
</tr>
<tr>
    <td><a href="facultyviewassignment.jsp">VIEWASSIGNMENT</a></td>
</tr>
<tr>
<td><a href="index.jsp">SIGNOUT</a></td>
</tr>
</tbody>
</table>
</td>
<td width="800">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:oradsn","system","system");
Statement st=con.createStatement();
//String username=(String)session.getAttribute("username");
ResultSet rs=st.executeQuery("select * from course");
%>
<form action="updatecourse.jsp" method="POST">
  <table border="1" align="center" width="20%">
<tbody>
<tr>

<th>courseid</th>
<th>coursename</th>
<th>duration</th>

</tr>
    <% while(rs.next())
        {
        %>
  
<tr>

<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
</tr>

    <%
    }
    %>
</table>

</form>
</td>
</tr>
</table>
    </body>
</html>
